The SIF record format also contains delta specific columns to assist in setting the indicator values of existing database records to NULL. SIF记录格式还包含特定于delta的列,以协助将现有数据库记录的指示符值设置为NULL。
Otherwise, an attempt to insert a record with a NULL value for the partitioning key will result in a "data out of bounds" error. 否则,在插入分区键列为NULL值的记录时,会产生“dataoutofbounds”错误。
Note that the test for null values is gone from the FOR statement, because you want to handle that condition by writing a diagnostic record. 注意,对null值的检查从FOR语句中消失了,因为希望通过写诊断记录来处理这种情况。
If one record set has more rows than the other, data in that column will continue while nulls will be displayed for the other as seen below. 如果一个记录集比另一个多,此列中的数据将会继续增加,而另一个显示null,如下所示。
Also, the IF statement has been inverted: you now test for null coordinates ( instead of NOT NULL)), write a log record if found, and proceed with the insert otherwise. 另外,IF语句已经反转了,现在检查null坐标(而不是NOTNULL),如果找到了,就写日志记录,否则就继续处理插入。